Tabela LPatientTypeEpisode

Definicja tabeli LPatientTypeEpisode

Name

LPatientTypeEpisode

Code

LPatientTypeEpisode

Comment

Polaczenie typu pacjenta z epizodem


Lista kolumn tabeli LPatientTypeEpisode

Name

Code

EpisodeID

EpisodeID

PatientTypeID

PatientTypeID

Active

Active

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson


Kolumna EpisodeID tabeli LPatientTypeEpisode

Definicja kolumny EpisodeID tabeli LPatientTypeEpisode

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID epizodu


Kolumna PatientTypeID tabeli LPatientTypeEpisode

Definicja kolumny PatientTypeID tabeli LPatientTypeEpisode

Name

PatientTypeID

Code

PatientTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID typu pacjenta


Kolumna Active tabeli LPatientTypeEpisode

Definicja kolumny Active tabeli LPatientTypeEpisode

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy aktywny


Kolumna InsertDate tabeli LPatientTypeEpisode

Definicja kolumny InsertDate tabeli LPatientTypeEpisode

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

Yes

Comment

Data utworzenia rekordu


Kolumna InsertingPerson tabeli LPatientTypeEpisode

Definicja kolumny InsertingPerson tabeli LPatientTypeEpisode

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Osoba tworzaca rekord


Kolumna LastModifiedDT tabeli LPatientTypeEpisode

Definicja kolumny LastModifiedDT tabeli LPatientTypeEpisode

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli LPatientTypeEpisode

Definicja kolumny LastModifiedPerson tabeli LPatientTypeEpisode

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Ostatnio modyfikujaca osoba


Lista kluczy tabeli LPatientTypeEpisode

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPatientTypeEpisode

Definicja klucza Identifier_1 tabeli LPatientTypeEpisode

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment